/**
 * menu表操作 
 */
var MenuData = {
    // 获取菜单数据
    queryMenuData: function() {
        return "select * from menu";
    },
    // 删除ID对应的数据
    deleteData: function(param) {
        return "DELETE from menu where ID = " + param.ID;
    },
    // 增加数据
    insertData: function(param) {
        return "INSERT INTO menu set name = '"+param.name+"' ,maddress='"+param.maddress+"' , parentID = '"+ param.parentID+"';";
    },
    // 更新数据
    updatetData: function(param) {
        return "UPDATE  menu SET name = '"+param.name+"'"+' , '+"maddress = '"+param.maddress+"'"+' , '+"parentID = '"+param.parentID+"'"+" WHERE ID = '"+param.ID+"'";
    }
}
exports = module.exports = MenuData;